StaffGroup

EntityType | Independent
Logical Entity Name | StaffGroup
Default Table Name | SyStaffGroup
Logical Only | NO
Owner | dbo
Definition |
Note |

StaffGroup Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
Code |  | CHAR(8) | NO |
Name |  | VARCHAR(40) | NO |
IsActive |  | BIT | NO |
ModFlag |  | CHAR(1) | NO |
IsSystemCode |  | BIT | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | YES |
RowVersion |  | TIMESTAMP/DATE | NO |
StaffGroupId |  | INTEGER | NO |
IsRequiredForEnroll |  | BIT | NO |
AdvisorModule |  | CHAR(8) | YES |
CanOverrideLeadDuplicateWarning |  | BIT | NO |
GroupType |  | CHAR(4) | YES |
AllowDropLDAAttendChange |  | BIT | NO |
IsCampusLinkAmbassadorUse |  | BIT | NO |
IsPositivePayUse |  | BIT | NO |
IsExcludedCrmIntegration |  | BIT | NO |

StaffGroup Keys

Key Name | Key Type | Keys
SyStaffGroup_AdvisorModule_N_N_IDX | Inversion Entry | AdvisorModule
SyStaffGroup_Code_N_N_IDX | Inversion Entry | Code
SyStaffGroup_SyStaffGroupID_U_C_IDX | PrimaryKey | StaffGroupId

StaffGroup Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Module | Non-Identifying | Zero or One to Zero or More |  |  |  | AdvisorModule | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
StudentAdvisor | Non-Identifying | One To Zero or More |  |  |  |  | NO
TaskAddTrigger | Non-Identifying | One To Zero or More |  |  |  |  | NO
cmStaffGroupAccess | Non-Identifying | One To Zero or More |  |  |  |  | NO
AutoAwardPaymentPlanSetting | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaCashPlanWorkflowAudit | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaCashPlanWorkflowAudit | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAwardPromNotePrintAssignment | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaPromNotePrintAudit | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaPromNotePrintAudit | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaStudentAidCashPlanAssignment | Non-Identifying | One To Zero or More |  |  |  |  | NO
AchBatchFileSetting | Non-Identifying | One To Zero or More |  |  |  |  | NO
BillingTransactionCodeStaffGroup | Non-Identifying | One To Zero or More |  |  |  |  | NO
DisbursementReceiptNotification | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentRt4CalculationPostWithdrawalDisbursementAssignment | Non-Identifying | One To Zero or More |  |  |  |  | NO
PostWithdrawalDisbursementConfigurationDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaPWDRoutingTemplate | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaRefundCalculationAssignment | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaRefundCalculationRoutingTemplate | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaRefundCalculationWorkflowAudit | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaRefundCalculationWorkflowAudit | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaReturnOfT4Assignment | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentRt4CalculationPostWithdrawalDisbursementAssignmentDataChange | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentRt4CalculationPostWithdrawalDisbursementAssignmentDataChange | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountTransactionPendingCheck | Non-Identifying | One To Zero or More |  |  |  |  | NO
Si_Packages_Security | Non-Identifying | One To Zero or More |  |  |  |  | NO
CampusDefaultStudentAdvisor | Identifying | One To Zero or More |  |  |  |  | NO
EmployerContactTypeStaffGroup | Non-Identifying | One To Zero or More |  |  |  |  | NO
StaffGroupFundSourcePermission | Non-Identifying | One To Zero or More |  |  |  |  | NO
SchoolStatusDetailStaffGroup | Identifying | One To Zero or More |  |  |  |  | NO
SecurityMenuAuthorization | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaaProcessExceptionAssignment | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaaProcessExceptionAssignment | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaaProcessExceptionDataChange | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaaProcessExceptionDataChange | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaaProcessExceptionDataChange | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaaProcessExceptionDataChange | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaaProcessExceptionTypeCampusTemplate | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaaProcessExceptionCustomActionDocumentReview | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaaProcessExceptionOverrideUser | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaaProcessExceptionSearchFilterUser | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaaProcessExceptionTypeTemplate | Non-Identifying | One To Zero or More |  |  |  |  | NO
SyServiceNotificationTemplateAssignment | Non-Identifying | One To Zero or More |  |  |  |  | NO
SyServicePerformanceGoalsAssignment | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaaStaffGroupDelegation | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaaStaffGroupHierarchy | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaaStaffGroupHierarchy | Non-Identifying | One To Zero or More |  |  |  |  | NO
StaffGroupMember | Non-Identifying | Zero or One to Zero or More |  |  |  |  | NO
StaffGroupRefreshRule | Non-Identifying | One To Zero or More |  |  |  |  | NO
StaffGroupTemplateSetting | Non-Identifying | One To Zero or More |  |  |  |  | NO
SyStatusGridStaffGroup | Identifying | One To Zero or More |  |  |  |  | NO
WorkspaceStaffGroup | Non-Identifying | One To Zero or More |  |  |  |  | NO
EmployerContactTypeStaffGroup | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAdvisorDataChange | Non-Identifying | Zero or One to Zero or More |  |  |  |  | NO
TaskPolicyDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO

StaffGroup Check Constraints

Check Constraint Name | CheckConstraint

StaffGroup Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StaffGroup | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyStaffGroup | NO |  |  |

StaffGroup Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Addresses_Affiliations
Logical | Employers
Logical | StudentEnrollment
Logical | Tasks
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | System

StaffGroup Data Movement Rules

Name | Type | Rule Text/Value